#!/usr/bin/env python
# encoding: utf-8
'''
@author: zhaowenpeng
@contact: winston@peipeiyun.com
@software: garner
@file: fetch_code_oe.py
@time: 2020/8/11 2:44 下午
@desc:
'''

import pandas as pd
data = []
df = pd.read_excel('禾田匹配数据(最后确定数据8.11).xlsx')
# df.set_index(['code', 'oe'], inplace=True)
print(df[['code']].head(10))
df1 = df[['code']]
df1.dropna(axis=0, how='any', inplace=True)
df1.to_csv('hetian_811.csv',index=False)